{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["BSC","ADMINISTRATIVA","MANTENIMIENTO","GESTION DE CALIDAD","COMUNICACION","JURIDICA","FINANCIERA","COMERCIALIZACIÓN","PLANEACION","GESTIÓN TECNOLOGICA","CONTROL DE CALIDAD","PRODUCCION","CONTROL INTERNO","BSC-CUADRO"],"not_rendered":{"charts":0,"images":32,"macros":1,"external_links":0,"defined_names":23,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BSC","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,0,1,10],[2,0,2,9],[0,0,0,9]]}
["INDUSTRIA  LICORERA DEL CAUCA"]
["BSC-CUADRO DE MANDO INTEGRAL"]
["PROCESOS"]

{"sheet":"ADMINISTRATIVA","index":1,"n_rows":26,"n_cols":28,"rows_kept":26,"cut":false,"hidden":false,"merged":[[22,0,23,0],[22,1,23,1],[13,3,13,9],[12,3,12,9],[12,0,13,0],[14,0,15,0],[16,0,17,0],[18,0,19,0],[12,2,13,2],[14,2,15,2],[16,2,17,2],[18,2,19,2],[16,3,16,9],[8,12,9,12],[8,14,9,14],[8,16,9,16],[8,0,9,0],[8,4,9,4],[8,6,9,6],[8,8,9,8],[8,10,9,10],[8,2,9,2],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,14],[2,15,3,20],[2,21,3,26],[6,26,7,26],[4,0,4,26],[6,0,7,0],[6,4,7,4],[6,6,7,6],[6,10,7,10],[6,2,7,2],[6,12,7,12],[6,14,7,14],[6,16,7,16],[6,18,7,18],[6,8,7,8],[10,0,11,0],[10,2,11,2],[10,25,11,26],[6,20,7,20],[8,26,9,26],[8,18,9,18],[8,20,9,20],[8,22,9,22],[8,24,9,24],[6,22,7,22],[6,24,7,24],[10,3,10,12],[11,3,11,12],[10,15,10,24],[11,15,11,24],[10,13,11,14],[12,26,13,26],[14,3,14,9],[14,10,15,10],[15,3,15,9],[12,11,12,17],[13,11,13,17],[14,11,14,17],[14,18,15,18],[15,11,15,17],[12,19,12,25],[13,19,13,25],[14,19,14,25],[14,26,15,26],[15,19,15,25],[12,10,13,10],[12,18,13,18],[16,10,17,10],[17,3,17,9],[18,3,18,9],[18,10,19,10],[19,3,19,9],[16,11,16,17],[16,18,17,18],[17,11,17,17],[18,11,18,17],[18,18,19,18],[19,11,19,17],[16,19,16,25],[16,26,17,26],[18,19,18,25],[18,26,19,26],[19,19,19,25]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n3 de 15"]
[]
["GESTIÓN DE CALIDAD"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["ALMACENAMIENTO CLIENTES","uds Cliente Bodega","<=33%",156.017,{"$f":"D7/D8","v":0.17335222222222221},97.254000000000005,{"$f":"F7/F8","v":0.10806},70.349999999999994,{"$f":"H7/H8","v":7.8166666666666662E-2},51.036000000000001,{"$f":"J7/J8","v":5.6706666666666669E-2},49.896000000000001,{"$f":"L7/L8","v":5.5440000000000003E-2},37.152000000000001,{"$f":"N7/N8","v":4.1280000000000004E-2},23.454000000000001,{"$f":"P7/P8","v":2.606E-2},9.5220000000000002,{"$f":"R7/R8","v":1.0580000000000001E-2},22.452000000000002,{"$f":"T7/T8","v":2.4946666666666669E-2},5.7,{"$f":"V7/V8","v":6.3333333333333332E-3},11.603999999999999,{"$f":"X7/X8","v":1.2893333333333333E-2},18.594000000000001,{"$f":"Z7/Z8","v":2.0660000000000001E-2}]
[null,"# uds Bodega",null,900,null,900,null,900,null,900,null,900,null,900,null,900,null,900,null,900,null,900,null,900,null,900]
["SGSST","Actividades del SGSST ejecutadas",1,1,{"$f":"D9/D10","v":1},1,{"$f":"F9/F10","v":1},1,{"$f":"H9/H10","v":1},5,{"$f":"J9/J10","v":1},6,{"$f":"L9/L10","v":1},8,{"$f":"N9/N10","v":1},10,{"$f":"P9/P10","v":1},8,{"$f":"R9/R10","v":1},9,{"$f":"T9/T10","v":0.9},9,{"$f":"V9/V10","v":0.9},10,{"$f":"X9/X10","v":1},7,{"$f":"Z9/Z10","v":0.875}]
[null,"Actividades del SGSST programadas",null,1,null,1,null,1,null,5,null,6,null,8,null,10,null,8,null,10,null,10,null,10,null,8]
["CAPACITACION","Total eventos de capacitación y formación realizados",0.8,5,null,null,null,null,null,null,null,null,null,{"$f":"D11/D12","v":0.16666666666666666},null,0,null,null,null,null,null,null,null,null,null,{"$f":"P11/P12","v":0}]
[null,"Total eventos de capacitación y formación programados",null,30,null,null,null,null,null,null,null,null,null,null,null,30]
["MANTENIMIENTO PREVENTIVO INFRAESTRUCTURA","Mantenimiento Preventivo        Realizado ",0.8,17,null,null,null,null,null,null,{"$f":"D13/D14","v":1},11,null,null,null,null,null,null,{"$f":"L13/L14","v":1},1,null,null,null,null,null,null,{"$f":"T13/T14","v":1}]
[null,"Mantenimiento Preventivo Programado",null,17,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,1]
["CUMPLIMEINTO MANTENIMIENTO CORRECTIVO INFRAESTRUCTURA","Cantidades de solicitudes resueltas",0.8,9,null,null,null,null,null,null,{"$f":"D15/D16","v":1},1,null,null,null,null,null,null,{"$f":"L15/L16","v":1},1,null,null,null,null,null,null,{"$f":"T15/T16","v":1},"pendiente Verificacion en terreno de cum,plimiento de actividades por la Division de Planeacion "]
[null,"Cantidades de solicitudes",null,9,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,1]
["MANTENIMIENTO PREVENTIVO VEHICULAR","Mantenimiento Preventivo        Realizado ",0.9,3,null,null,null,null,null,null,{"$f":"D17/D18","v":1},1,null,null,null,null,null,null,{"$f":"L17/L18","v":1},1,null,null,null,null,null,null,{"$f":"T17/W18","v":1}]
[null,"Mantenimiento Preventivo Programado",null,3,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,1]
["CUMPLIMEINTO MANTENIMIENTO CORRECTIVO VEHICULAR","Mantenimiento Correctivo   Realizado ",0.9,6,null,null,null,null,null,null,{"$f":"D19/D20","v":1},1,null,null,null,null,null,null,{"$f":"L19/L20","v":1},1,null,null,null,null,null,null,{"$f":"T19/T20","v":1}]
[null,"Mantenimiento Correctivo Programado",null,6,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,1]
[]
["RESPONSABLE","Jefe Division Administrativa"]
[]
[]
["N"]

{"sheet":"MANTENIMIENTO","index":2,"n_rows":17,"n_cols":27,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,0,4,26],[6,8,7,8],[6,10,7,10],[6,12,7,12],[6,0,7,0],[6,2,7,2],[6,24,7,24],[6,26,7,26],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,15],[2,16,3,26],[15,0,16,0],[15,1,16,1],[6,20,7,20],[6,22,7,22],[6,6,7,6],[10,0,11,0],[10,2,11,2],[6,4,7,4],[10,4,11,4],[6,14,7,14],[6,16,7,16],[6,18,7,18]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,null,"Página \n4 de 13"]
[]
["MANTENIMIENTO"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["% DISPONIBILIDAD","     Tiempo Total de Operación","69%  o menor:Malo                                             70% - 79% : Regular                                          80% - 89%  : Bueno                                           90% - 94% : Optimo                                            95% - 100% : Fuera de rango posible",760,{"$f":"D7/D8","v":0.91566265060240959},892,{"$f":"F7/F8","v":0.86770428015564205},4260,{"$f":"H7/H8","v":0.88713036234902121},13550,{"$f":"J7/J8","v":0.8303713690403236},6390,{"$f":"L7/L8","v":0.89621318373071523},19705,{"$f":"N7/N8","v":0.83929636255217654},17840,{"$f":"P7/P8","v":0.83372277782970372},20650,{"$f":"R7/R8","v":0.80469176213857063},19720,{"$f":"T7/T8","v":0.87144814176499186},14875,{"$f":"V7/V8","v":0.79156023839931888},15470,{"$f":"X7/X8","v":0.82252233092301152},9190,{"$f":"Z7/Z8","v":0.9031941031941032}]
[null,"Tiempo de Operación + Tiempo de paradas",null,830,null,1028,null,4802,null,{"$f":"J7+2768","v":16318},null,{"$f":"6390+740","v":7130},null,{"$f":"19705+3773","v":23478},null,{"$f":"17840+3558","v":21398},null,{"$f":"20650+5012","v":25662},null,{"$f":"19720+2909","v":22629},null,{"$f":"V7+3917","v":18792},null,{"$f":"15470+3338","v":18808},null,{"$f":"Z7+985","v":10175}]
[]
["NOMBRE","FORMULA ","META","Año","%"]
["COSTO TOTAL DE MANTENIMIENTO POR FACTURACIÓN"," Costo Total de Mto por Facturación","<= 2% de la facturacion",{"$f":"2901789+338680958+15000000","v":356582747},{"$f":"D11/D12","v":7.8581250780619429E-3},"Costo de los proyectos ejecutados en el año necesarios para el mantenimiento de la infraestructura de producción y compras de nuevos equipos."]
[null,"Facturación Total en el periodo",null,45377586060,null,"Facturación del año 2021 sin incluir impuestos"]
[]
[]
[]
["RESPONSABLE","Profesional Universitario de Mantenimiento"]
[null,null,null,null,null," "]

{"sheet":"GESTION DE CALIDAD","index":3,"n_rows":12,"n_cols":27,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,18,9,18],[8,20,9,20],[8,22,9,22],[8,24,9,24],[8,26,9,26],[8,8,9,8],[8,10,9,10],[8,12,9,12],[8,14,9,14],[8,16,9,16],[6,1,7,1],[8,0,9,0],[8,1,9,1],[8,4,9,4],[8,6,9,6],[6,2,9,2],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,14],[2,15,3,20],[2,21,3,26],[11,0,12,0],[11,1,12,1],[4,0,4,26],[6,10,7,10],[6,12,7,12],[6,14,7,14],[6,0,7,0],[6,4,7,4],[6,6,7,6],[6,8,7,8],[6,16,7,16],[6,18,7,18],[6,20,7,20],[6,22,7,22],[6,24,7,24],[6,26,7,26]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n3 de 15"]
[]
["GESTIÓN DE CALIDAD"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["ESTADO DE ACCIONES CORRECTIVAS"," No conformidades de auditoria interna cerradas / Total no conformidades de auditoria interna ",">=70%",0,{"$f":"D7/D8","v":0},0,{"$f":"F7/F8","v":0},0,{"$f":"H7/H8","v":0},0,{"$f":"J7/J8","v":0},0,{"$f":"L7/L8","v":0},0,{"$f":"N7/N8","v":0},0,{"$f":"P7/P8","v":0},0,{"$f":"R7/R8","v":0},0,{"$f":"T7/T8","v":0},0,{"$f":"V7/V8","v":0},0,{"$f":"X7/X8","v":0},22,{"$f":"Z7/Z8","v":0.45833333333333331}]
[null,null,null,1,null,1,null,1,null,1,null,1,null,1,null,7,null,5,null,11,null,17,null,8,null,48]
["AUDITORIA INTERNA"," Auditoria interna realizadas/Total auditorías internas programadas",null,0,{"$f":"D9/D10","v":0},0,"%",0,{"$f":"H9/H10","v":0},0,{"$f":"J9/J10","v":0},0,{"$f":"L9/L10","v":0},0,{"$f":"N9/N10","v":0},4,{"$f":"P9/P10","v":0.30769230769230771},2,{"$f":"R9/R10","v":0.15384615384615385},1,0.09,3,{"$f":"V9/V10","v":0.23076923076923078},3,{"$f":"X9/X10","v":0.23076923076923078},0,{"$f":"Z9/Z10","v":0}]
[null,null,null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13]
[]
["RESPONSABLE","Representante de la Dirección Coordinador de Calidad"]

{"sheet":"COMUNICACION","index":4,"n_rows":13,"n_cols":27,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,14],[2,15,3,20],[2,21,3,26],[6,26,7,26],[4,0,4,26],[6,0,7,0],[6,2,9,2],[6,4,7,4],[6,6,7,6],[6,8,7,8],[6,10,7,10],[6,12,7,12],[6,14,7,14],[6,16,7,16],[6,18,7,18],[6,20,7,20],[6,22,7,22],[6,24,7,24],[8,24,9,24],[8,26,9,26],[11,0,12,0],[11,1,12,1],[8,12,9,12],[8,14,9,14],[8,16,9,16],[8,18,9,18],[8,20,9,20],[8,22,9,22],[8,0,9,0],[8,4,9,4],[8,6,9,6],[8,8,9,8],[8,10,9,10]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n3 de 15"]
[]
["GESTIÓN DE CALIDAD"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["PLAN DE MEDIOS","No. de medios contratados",0.8,1,{"$f":"D7/D8","v":1},1,{"$f":"F7/F8","v":1},1,{"$f":"H7/H8","v":1},1,{"$f":"J7/J8","v":1},1,{"$f":"L7/L8","v":1},1,{"$f":"N7/N8","v":1},1,{"$f":"P7/P8","v":1},1,{"$f":"R7/R8","v":1},1,{"$f":"T7/T8","v":1},1,{"$f":"V7/V8","v":1},1,{"$f":"X7/X8","v":1},1,{"$f":"Z7/Z8","v":1}]
[null,"No. total de medios potenciales",null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1]
["CAMPAÑAS","No. de Campañas Realizadas",null,1,{"$f":"D9/D10","v":1},1,{"$f":"F9/F10","v":1},1,{"$f":"H9/H10","v":1},2,{"$f":"J9/J10","v":1},2,{"$f":"L9/L10","v":1},3,{"$f":"N9/N10","v":1},1,{"$f":"P9/P10","v":1},1,{"$f":"R9/R10","v":1},1,{"$f":"T9/T10","v":1},1,{"$f":"V9/V10","v":1},1,{"$f":"X9/X10","v":1},1,{"$f":"Z9/Z10","v":1}]
[null,"No. total de Campañas planeadas",null,1,null,1,null,1,null,2,null,2,null,3,null,1,null,1,null,1,null,1,null,1,null,1]
[]
["RESPONSABLE","Profesional en Comunicaciones"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]

{"sheet":"JURIDICA","index":5,"n_rows":11,"n_cols":27,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,20,7,20],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,3],[2,4,3,8],[2,9,3,14],[2,15,3,26],[10,0,11,0],[10,1,11,1],[4,0,4,26],[6,0,7,0],[6,2,7,2],[6,18,7,18],[6,16,7,16],[6,14,7,14],[6,12,7,12],[6,10,7,10],[6,8,7,8],[6,6,7,6],[6,4,7,4],[6,26,7,26],[6,24,7,24],[6,22,7,22]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,null,"Versión\n04",null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n11 de 15"]
[]
["JURIDICA"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["CONTRATOS OPORTUNOS","Número de contratos realizados ",1,6,{"$f":"D7/D8","v":1},15,{"$f":"F7/F8","v":1},27,{"$f":"H7/H8","v":1},11,{"$f":"J7/J8","v":1},12,{"$f":"L7/L8","v":1},12,{"$f":"N7/N8","v":1},16,{"$f":"P7/P8","v":1},11,{"$f":"R7/R8","v":1},17,{"$f":"T7/T8","v":1},24,{"$f":"V7/V8","v":1},32,{"$f":"X7/X8","v":1},35,{"$f":"Z7/Z8","v":1}]
[null," Números de contratos solicitados",null,6,null,15,null,27,null,11,null,12,null,12,null,16,null,11,null,17,null,24,null,32,null,35]
[]
[]
["RESPONSABLE","Jefe División Juridica"]

{"sheet":"FINANCIERA","index":6,"n_rows":11,"n_cols":29,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,0,4,26],[6,2,7,2],[6,0,7,0],[6,4,7,4],[6,26,7,26],[6,24,7,24],[6,22,7,22],[6,20,7,20],[2,8,3,13],[2,14,3,26],[10,0,11,0],[10,1,11,1],[6,18,7,18],[6,16,7,16],[6,14,7,14],[6,12,7,12],[6,10,7,10],[6,8,7,8],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,7],[6,6,7,6]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n13 de 13"]
[]
["ADMINISTRATIVA Y FINANCIERA"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Agos","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["MARGEN OPERACIONAL","Utilidad Operacional",">=17%",-1272232757,{"$f":"D7/D8","v":-54.001859866663708},-1943167028,{"$f":"F7/F8","v":-2.3811300088182881},-1149448219,{"$f":"H7/H8","v":-0.35748883626014838},106363070,{"$f":"J7/J8","v":1.5662754510756504E-2},421115546,{"$f":"L7/L8","v":4.6345444498942297E-2},2415918865,{"$f":"N7/N8","v":0.16359871931676054},3528843859,{"$f":"P7/P8","v":0.19466207402212959},5717075240,{"$f":"R7/R8","v":0.24535500225989804},8604412212,{"$f":"T7/T8","v":0.30399356705877589},9556597236,{"$f":"V7/X8","v":0.24978051533219744},11375624193,{"$f":"X7/X8","v":0.29732437215720209},14756480953,{"$f":"+Z7/Z8","v":0.32269276168183259},null,"La Division de Planeacion recomienda revisar el indicador para poder realizar un analisis mas exacto del desempeño realizado por la Division Financiera"]
[null,"Ingresos Netos",null,23559054.449999999,null,816069269.97000003,null,3215340179.6399999,null,6790827879.4099998,null,9086449608,null,14767345826.969999,null,18128050246.700001,null,23301237746.700001,null,28304586492.57,null,33156466933,null,38259978859,null,45729197259]
[]
[]
["RESPONSABLE","Jefe División\nFinanciera."]

{"sheet":"COMERCIALIZACIÓN","index":7,"n_rows":18,"n_cols":29,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,27,7,27],[4,0,4,27],[6,26,7,26],[6,24,7,24],[6,22,7,22],[6,0,7,0],[0,0,3,0],[0,1,0,27],[1,1,1,27],[2,1,3,3],[2,4,3,9],[2,10,3,16],[2,17,3,27],[16,0,17,0],[16,1,17,1],[6,20,7,20],[6,2,7,2],[6,4,7,4],[6,6,7,6],[6,12,7,12],[6,10,7,10],[6,8,7,8],[6,18,7,18],[6,16,7,16],[6,14,7,14],[9,0,10,0],[9,2,10,2],[9,4,10,4],[9,6,10,6],[9,8,10,8],[9,10,10,10],[9,12,10,12],[9,14,10,14],[9,16,10,16],[9,18,10,18],[9,20,10,20],[9,22,10,22],[9,24,10,24],[9,26,10,26],[9,27,10,27],[12,0,13,0],[12,2,13,2],[12,4,13,4],[12,6,13,6],[12,8,13,8],[12,10,13,10],[12,12,13,12],[12,14,13,14],[12,16,13,16],[12,18,13,18],[12,20,13,20],[12,22,13,22],[12,24,13,24],[12,26,13,26],[12,27,13,27]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,null,"Página \n9 de 13"]
[]
["COMERCIALIZACIÓN"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%","Año"]
["VENTAS","Número de unidades vendidas",1,0,{"$f":"D7/D8","v":0},58079,{"$f":"F7/F8","v":1.6133055555555557E-2},180734,{"$f":"H7/H8","v":5.0203888888888888E-2},260189,{"$f":"J7/J8","v":7.2274722222222226E-2},169521,{"$f":"L7/L8","v":4.7089166666666668E-2},420556,{"$f":"N7/N8","v":0.11682111111111111},241035,{"$f":"P7/P8","v":6.6954166666666662E-2},388526,{"$f":"R7/R8","v":0.10792388888888889},365610,{"$f":"T7/T8","v":9.374615384615384E-2},361362,{"$f":"V7/V8","v":9.2656923076923081E-2},362130,{"$f":"X7/X8","v":9.2853846153846148E-2},546038,{"$f":"Z7/Z8","v":0.14000974358974358},{"$f":"AC7/3900000","v":0.85994358974358975},{"$f":"Z7+X7+V7+T7+R7+P7+N7+L7+J7+H7+F7+D7/39000000","v":3353780}]
[null,"total meta de ventas",null,3600000,null,3600000,null,3600000,null,3600000,null,3600000,null,3600000,null,3600000,null,3600000,null,3900000,null,3900000,null,3900000,null,3900000]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%","Año"]
["RECLAMOS","No. Clientes satisfechos de R",0.8,6,{"$f":"D10/D11","v":1},5,{"$f":"F10/F11","v":1},2,{"$f":"H10/H11","v":0.66666666666666663},4,{"$f":"J10/J11","v":1},1,{"$f":"L10/L11","v":1},5,{"$f":"N10/N11","v":1},4,{"$f":"P10/P11","v":1},6,{"$f":"R10/R11","v":1},3,{"$f":"T10/T11","v":1},5,{"$f":"V10/V11","v":1},1,{"$f":"X10/X11","v":1},1,{"$f":"Z10/Z11","v":1},{"$f":"AVERAGE(E10,G10,I10,K10,M10,O10,Q10,S10,U10,W10,Y10,AA10)","v":0.97222222222222221}]
[null,"No. R presentados.",null,6,null,5,null,3,null,4,null,1,null,5,null,4,null,6,null,3,null,5,null,1,null,1]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%","Año"]
["SATISFACCION","No. Consumidores satisfechos",0.8,0,{"$f":"D13/D14","v":0},0,{"$f":"F13/F14","v":0},0,{"$f":"H13/H14","v":0},0,{"$f":"J13/J14","v":0},0,{"$f":"L13/L14","v":0},339,{"$f":"N13/N14","v":0.952247191011236},0,{"$f":"P13/P14","v":0},0,{"$f":"R13/R14","v":0},0,{"$f":"T13/T14","v":0},0,{"$f":"V13/V14","v":0},0,{"$f":"X13/X14","v":0},617,{"$f":"Z13/Z14","v":0.93768996960486317},{"$f":"AVERAGE(O13,AA13)","v":0.94496858030804964}]
[null,"total consumidores encuestados",null,1,null,1,null,1,null,1,null,1,null,356,null,1,null,1,null,1,null,1,null,1,null,658]
[]
[]
["RESPONSABLE","Jefe División Comercialización"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"PLANEACION","index":8,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,4,9,4],[8,6,9,6],[8,1,9,1],[11,0,12,0],[11,1,12,1],[8,0,9,0],[8,2,9,2],[0,0,3,0],[0,1,0,6],[1,1,1,6],[2,1,3,1],[2,2,3,2],[2,3,3,4],[2,5,3,6],[4,0,4,6],[6,0,7,0],[6,6,7,6],[6,4,7,4],[6,2,7,2]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03","Versión\n04","Fecha vigencia\nJulio 16 de 2018",null,"Página \n12 de 13"]
[]
["PLANEACIÓN"]
["NOMBRE","FORMULA ","META","1S","%","2S","%"]
["PROYECTOS","Número de Proyectos  Ejecutados ",">=90%",2,{"$f":"D7/D8","v":1},2,{"$f":"F7/F8","v":1}]
[null," Número de Proyectos  Elaborados",null,2,null,2]
["FORMULACION PLAN ESTRATEGICO 2019-2022","Avances",1,50,{"$f":"D9/D10","v":1},50,{"$f":"F9/F10","v":1}]
[null,null,null,50,null,50]
[]
["RESPONSABLE","Jefe División planeación."]

{"sheet":"GESTIÓN TECNOLOGICA","index":9,"n_rows":14,"n_cols":27,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,3],[2,4,3,9],[2,10,3,16],[2,17,3,26],[11,0,12,0],[11,1,12,1],[4,0,4,26],[6,2,7,2],[6,0,7,0],[6,4,7,4],[6,8,7,8],[6,6,7,6],[6,14,7,14],[6,12,7,12],[6,10,7,10]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,null,"Página \n8 de 13"]
[]
["GESTIÓN TECNOLOGICA"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["SOPORTE","# de solicitudes soporte",1,57,{"$f":"D7/D8","v":1},60,{"$f":"F7/F8","v":1},63,{"$f":"H7/H8","v":1},60,{"$f":"J7/J8","v":1},60,{"$f":"L7/L8","v":1},60,{"$f":"N7/N8","v":1},55,{"$f":"P7/P8","v":1},63,{"$f":"R7/R8","v":1},66,{"$f":"T7/T8","v":1},60,{"$f":"V7/V8","v":1},60,{"$f":"X7/X8","v":1},69,{"$f":"Z7/Z8","v":1}]
[null,"# Total de solicitudes recibidas",null,57,null,60,null,63,null,60,null,60,null,60,null,55,null,63,null,66,null,60,null,60,null,69]
["MANTENIMIENTO","# Mantenimiento Preventivos ejecutados",1,null,null,null,null,null,null,null,null,36,{"$f":"L9/L10","v":1},33,{"$f":"N9/N10","v":0.84615384615384615}]
[null,"# Mantenimientos Programados",null,null,null,null,null,null,null,null,null,36,null,39]
[]
["RESPONSABLE","Técnico Programador de Sistemas "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"              "]

{"sheet":"CONTROL DE CALIDAD","index":10,"n_rows":26,"n_cols":27,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,0,4,26],[9,26,10,26],[9,24,10,24],[9,22,10,22],[9,20,10,20],[6,26,7,26],[6,24,7,24],[6,22,7,22],[6,20,7,20],[6,18,7,18],[6,16,7,16],[6,14,7,14],[6,12,7,12],[6,10,7,10],[6,8,7,8],[6,4,7,4],[6,6,7,6],[9,18,10,18],[9,16,10,16],[9,14,10,14],[9,12,10,12],[9,10,10,10],[13,0,14,0],[13,1,14,1],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,14],[2,15,3,26],[6,0,7,0],[9,0,10,0],[9,2,10,2],[6,2,7,2],[9,8,10,8],[9,6,10,6],[9,4,10,4]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n15 de 13"]
[]
["CONTROL DE CALIDAD"]
["NOMBRE","FORMULA ","META",null,"%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["RECLAMOS ATENDIDOS","Concepto tecnico  ",1,3,{"$f":"D7/D8","v":1},5,{"$f":"F7/F8","v":1},2,{"$f":"H7/H8","v":1},3,{"$f":"J7/J8","v":1},0,{"$f":"L7/L8","v":0},5,{"$f":"N7/N8","v":1},3,{"$f":"P7/P8","v":1},6,{"$f":"R7/R8","v":1},3,{"$f":"T7/T8","v":1},0,{"$f":"V7/V8","v":0},0,{"$f":"X7/X8","v":0},0,{"$f":"Z7/Z8","v":0}]
[null,"Total reclamos recibidos en el mes",null,3,null,5,null,2,null,3,null,1,null,5,null,3,null,6,null,3,null,1,null,1,null,1]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["PRODUCTOS NO CONFORMES","Numero De Productos no conformes ","<=3%",173,{"$f":"D10/D11","v":2.3947951273532667E-2},122,{"$f":"F10/F11","v":1.0319393693327919E-3},1112,{"$f":"H10/H11","v":3.558901093273933E-3},1030,{"$f":"J10/J11","v":2.5045470903484967E-3},329,{"$f":"L10/L11","v":2.2073722206567099E-3},2242,{"$f":"N10/N11","v":3.5756207098930821E-3},1389,{"$f":"P10/P11","v":3.3439260436227071E-3},3481,{"$f":"R10/R11","v":6.6130178234223552E-3},2555,{"$f":"T10/T11","v":1.510047281323877E-2},0,{"$f":"V10/V11","v":0},0,{"$f":"X10/X11","v":0},0,{"$f":"Z10/Z11","v":0}]
[null,"Lotes de PT",null,7224,null,118224,null,312456,null,411252,null,149046,null,627024,null,415380,null,526386,null,169200,null,1,null,1,null,1]
[]
[]
["RESPONSABLE","Profesional Universitario Control Calidad"]
[]
[]
[]
[]
[]
[]
[]
[null,"Incremento en el porcentaje debido a el mantenimiento, ajustes y ensayo de los equipos de la linea "]
[null,"no se recepciono reclamos "]
[]
[]
[null,"No se recepcionaron reclamos en ese periodo de tiempo"]

{"sheet":"PRODUCCION","index":11,"n_rows":15,"n_cols":31,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,3,0],[0,1,0,27],[1,1,1,27],[2,1,3,2],[2,3,3,7],[2,8,3,12],[2,13,3,17],[2,18,3,27],[10,26,11,26],[10,0,11,0],[10,12,11,12],[10,14,11,14],[10,16,11,16],[10,18,11,18],[10,20,11,20],[10,2,11,2],[10,4,11,4],[10,6,11,6],[10,8,11,8],[10,10,11,10],[7,18,8,18],[7,20,8,20],[7,22,8,22],[7,24,8,24],[10,22,11,22],[10,24,11,24],[14,0,15,0],[14,1,15,1],[12,11,13,11],[5,0,5,27],[4,0,4,16383],[7,26,8,26],[7,27,8,27],[7,0,8,0],[7,2,8,2],[7,4,8,4],[7,6,8,6],[7,8,8,8],[7,10,8,10],[7,12,8,12],[7,14,8,14],[7,16,8,16]]}
[null," INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,"Página \n2 de 13"]
[]
[]
["PRODUCCIÓN"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%",5,"%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%","Año"]
["PRODUCION","Total     Unidades     producidas",1,{"$f":"(200+201)*12","v":4812},{"$f":"D8/D$9","v":1},71112,{"$f":"F8/F$9","v":0.16162112038400697},285864,{"$f":"H8/H$9","v":0.66721127049849926},{"$f":"(11099+12073)*12","v":278064},{"$f":"J8/J$9","v":0.60978947368421055},{"$f":"((5550+561)*12)+((1018+501)*14)","v":94598},{"$f":"L8/L$9","v":0.26277222222222224},5,{"$f":"N8/N$9","v":1.4619883040935673E-5},246900,{"$f":"P8/P$9","v":0.73482142857142863},{"$f":"((1512+10246+14369)*12)+((9682+2279)*14)","v":480978},{"$f":"R8/R$9","v":1.2354817828740521},{"$f":"(21379+15543)*12","v":443064},{"$f":"T8/T$9","v":1.9432631578947368},{"$f":"(11818+13293+378)*12","v":305868},{"$f":"V8/V$9","v":1.2997960224375318},{"$f":"(17752+315+10607)*12","v":344088},{"$f":"X9/X$9","v":1},{"$f":"(7021*12)+(8872+2064*14)","v":122020},{"$f":"Z8/Z$9","v":1},0.88149999999999995,{"$f":"(D8+F8+H8+J8+L8+N8+P8+R8+T8+V8+X8+Z8)","v":2677373}]
[null,"Total de Unidades Programadas",null,4812,null,439992,null,428446,null,{"$f":"38000*12","v":456000},null,{"$f":"30000*12","v":360000},null,{"$f":"28500*12","v":342000},null,336000,null,{"$f":"32442*12","v":389304},null,{"$f":"19000*12","v":228000},null,{"$f":"19610*12","v":235320},null,{"$f":"11665*12","v":139980},null,122020,null,null,{"$f":"F90+H9+J9+L9+N9+P9+R9+T9+V9+X9+Z9","v":3037070},{"$f":"(AC8*100)/AC9","v":88.156446838564804},"las unidades programadas del mes de enero y diciembre deben corresponder a las unidades producidas "]
[null,null,null,null,null,null,null,null,null,null,null,"|"]
["REDUCIR EL IMPACTO AMBIENTAL EN EL MANEJO DE LOS RESIDUOS DE LA PRODUCCIÓN","Total de Bajas (Etiqueta, Tapa, Cartón) Año Actual ","<1,5%",38,{"$f":"D11/D12","v":7.8969243557772233E-3},{"$f":"75+26+366+363+50+19+11+15+50+28","v":1003},{"$f":"F11/F12","v":2.2795869015800286E-3},{"$f":"102+64+32+338+884+198+709+22+46+79+19+11+67+28","v":2599},{"$f":"H11/H12","v":6.0661086811406809E-3},2522,{"$f":"J11/J12","v":5.530701754385965E-3},{"$f":"193+7+13+457+20+248+155+53+10+11+50+29","v":1246},{"$f":"L11/L12","v":3.461111111111111E-3},{"$f":"546+584+10+717+10+10+10+134+163+145+75+147","v":2551},{"$f":"N11/N12","v":5.3852649356132577E-3},{"$f":"174+56+616+277+64+238+64+31+222+49","v":1791},{"$f":"P11/P12","v":5.3303571428571428E-3},{"$f":"91+118+87+3+30+472+240+770+111+10+144+82+93+43+109+56+102","v":2561},{"$f":"R11/R12","v":6.5784065922775007E-3},{"$f":"182+982+357+138+56+5+288+26","v":2034},{"$f":"T11/T12","v":8.9210526315789476E-3},{"$f":"(134+980+206+107+49+6+2+92+55)","v":1631},{"$f":"V11/V12","v":6.9309875913649496E-3},1563,{"$f":"(X11*100)/X12","v":0.45424426309548721},{"$f":"45+208+151+179+519+143+14+27+60+28+109+159","v":1642},{"$f":"Z11/Z12","v":1.3456810358957547E-2}]
[null,"Total Unidades Producidas",null,4812,null,439992,null,428446,null,456000,null,{"$f":"30000*12","v":360000},null,473700,null,336000,null,389304,null,228000,null,235320,null,344088,null,122020]
[]
[]
["RESPONSABLE","Jefe División Producción"]

{"sheet":"CONTROL INTERNO","index":12,"n_rows":22,"n_cols":27,"rows_kept":22,"cut":false,"hidden":false,"merged":[[18,0,19,0],[18,2,19,2],[18,4,19,4],[18,6,19,6],[10,12,11,12],[10,14,11,14],[14,0,15,0],[14,2,15,2],[14,4,15,4],[14,6,15,6],[14,8,15,8],[14,10,15,10],[14,12,15,12],[14,14,15,14],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,15],[2,16,3,26],[6,6,7,6],[10,10,11,10],[10,0,11,0],[10,2,11,2],[10,4,11,4],[10,6,11,6],[10,8,11,8],[21,0,22,0],[21,1,22,1],[4,0,4,26],[6,8,7,8],[6,10,7,10],[6,12,7,12],[6,14,7,14],[6,16,7,16],[6,18,7,18],[6,20,7,20],[6,22,7,22],[6,24,7,24],[6,26,7,26],[6,2,7,2],[6,0,7,0],[6,4,7,4]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2020"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,null,"Página \n5 de 15"]
[]
["CONTROL INTERNO"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["AUDITORIA INTERNA ","Numero de auditorías de Control Interno realizadas en el Programa Anual de Auditorias ",">=100%",0,{"$f":"D7/$D$8","v":0},0,{"$f":"F7/F8","v":0},0,{"$f":"H7/$D$8","v":0},0,{"$f":"J7/$D$8","v":0},0,{"$f":"L7/$D$8","v":0},0,{"$f":"N7/$D$8","v":0},4,{"$f":"P7/$D$8","v":0.30769230769230771},2,{"$f":"R7/$D$8","v":0.15384615384615385},1,{"$f":"T7/$D$8","v":7.6923076923076927E-2},3,{"$f":"V7/$D$8","v":0.23076923076923078},3,{"$f":"X7/$D$8","v":0.23076923076923078},null,1]
[null,"total de auditorías de Control Interno establecidas en el Programadas Anual de Auditorias   *100",null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13]
[]
["NOMBRE","FORMULA ","META","1B","%","2B","%","3B","%","4B","%","5B","%","6B","%","7B","%","8B","%","9B","%","10B","%","11B","%","12B","%"]
["ENTES EXTERNOS","Numero de Informes de Ley presentados",1,4,{"$f":"D11/D12","v":1},2,{"$f":"F11/F12","v":1},2,{"$f":"H11/H12","v":1},1,{"$f":"J11/J12","v":1},1,{"$f":"L11/L12","v":1},1,{"$f":"N11/N12","v":1},1,{"$f":"P11/P12","v":1},2,{"$f":"R11/R12","v":1},1,{"$f":"T11/T12","v":1},0,{"$f":"V11/V12","v":{"$error":"#DIV/0!"}},1,1,0,1]
[null,"Total de Informes de Ley a presentar",null,4,null,2,null,2,null,1,null,1,null,1,null,1,null,2,null,1,null,0,null,1,null,0]
[]
["NOMBRE","FORMULA ","META","1B","%","2B","%","3B","%","4B","%","5B","%","6B","%","7B","%","8B","%","9B","%","10B","%","11B","%","12B","%"]
["SIA","Nº de requerimientos publicados",1,3,{"$f":"D15/D16","v":1},1,{"$f":"F15/F16","v":1},1,{"$f":"H15/H16","v":1},1,{"$f":"J15/J16","v":1},1,{"$f":"L15/L16","v":1},2,1,1,1,2,1,0,1,2,{"$f":"V15/V16","v":1},0,{"$f":"X15/X16","v":{"$error":"#DIV/0!"}},0,1]
[null,"Total de requerimientos en SIA Contralorías",null,3,null,1,null,1,null,1,null,1,null,2,null,1,null,2,null,0,null,2,null,0,null,0]
[]
["NOMBRE","FORMULA ","META","1S","%","2S","%"]
["PLANES DE MEJORAMIENTO","Nº de Instrumentos adoptados",1,2,{"$f":"D19/D20","v":1},2,{"$f":"F19/F20","v":1}]
[null,"Total de Instrumentos del Decreto 648/17 Art. 2.2.21.4.8",null,2,null,2]
[]
["RESPONSABLE","Jefe Oficina de Control Interno"]

{"sheet":"BSC-CUADRO","index":13,"n_rows":33,"n_cols":29,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,0,32,0],[22,17,22,18],[9,0,10,0],[1,0,3,0],[0,1,0,28],[1,1,1,28],[2,1,3,2],[2,3,3,6],[2,7,3,11],[2,12,3,16],[2,17,3,28],[4,0,4,28],[5,27,5,28],[19,0,20,0],[21,0,21,16383],[5,0,5,25],[13,0,14,0],[7,0,8,0],[28,6,28,7],[28,0,28,5],[22,0,22,13],[24,0,26,0]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2021"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03\n",null,"Versión\n04\n",null,null,null,"Fecha vigencia\nJulio  16 de 2018\n",null,null,null,null,"Página \n1 de 13\n"]
[]
[]
["MENSUAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANUAL"]
["PROCESOS","INDICADOR","ENE","META","FEB.","META","MAR.","META","ABR.","META","MAY.","META","JUN.","META","JUL.","META","AGO.","META","SEP.","META","OCT.","META","NOV.","META","DIC.","META",null,"AÑO","META"]
["PRODUCCION","PLAN DE PRODUCCIÓN",{"$f":"PRODUCCION!E8","v":1},{"$f":"IF(C8>=80%,1,0)","v":1},{"$f":"PRODUCCION!G8","v":0.16162112038400697},{"$f":"IF(E8>=80%,1,0)","v":0},{"$f":"PRODUCCION!I8","v":0.66721127049849926},{"$f":"IF(G8>=80%,1,0)","v":0},{"$f":"PRODUCCION!K8","v":0.60978947368421055},{"$f":"IF(I8>=80%,1,0)","v":0},{"$f":"PRODUCCION!M8","v":0.26277222222222224},{"$f":"IF(K8>=80%,1,0)","v":0},{"$f":"PRODUCCION!O8","v":1.4619883040935673E-5},{"$f":"IF(M8>=80%,1,0)","v":0},{"$f":"PRODUCCION!Q8","v":0.73482142857142863},{"$f":"IF(O8>=80%,1,0)","v":0},{"$f":"PRODUCCION!S8","v":1.2354817828740521},{"$f":"IF(Q8>=80%,1,0)","v":1},{"$f":"PRODUCCION!U8","v":1.9432631578947368},{"$f":"IF(S8>=80%,1,0)","v":1},{"$f":"PRODUCCION!W8","v":1.2997960224375318},{"$f":"IF(U8>=80%,1,0)","v":1},{"$f":"PRODUCCION!Y8","v":1},{"$f":"IF(W8>=80%,1,0)","v":1},{"$f":"PRODUCCION!AA8","v":1},{"$f":"IF(Y8>=80%,1,0)","v":1},null,{"$f":"PRODUCCION!AB8","v":0.88149999999999995},{"$f":"IF(AB8>=70%,1,0)","v":1}]
[null,"REDUCIR EL IMPACTO AMBIENTAL EN EL MANEJO DE LOS RESIDUOS DE LA PRODUCCIÓN",{"$f":"PRODUCCION!E11","v":7.8969243557772233E-3},{"$f":"IF(C9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!G11","v":2.2795869015800286E-3},{"$f":"IF(E9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!I11","v":6.0661086811406809E-3},{"$f":"IF(G9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!K11","v":5.530701754385965E-3},{"$f":"IF(I9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!M11","v":3.461111111111111E-3},{"$f":"IF(K9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!O11","v":5.3852649356132577E-3},{"$f":"IF(M9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!Q11","v":5.3303571428571428E-3},{"$f":"IF(O9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!S11","v":6.5784065922775007E-3},{"$f":"IF(Q9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!U11","v":8.9210526315789476E-3},{"$f":"IF(S9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!W11","v":6.9309875913649496E-3},{"$f":"IF(U9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!Y11","v":0.45424426309548721},{"$f":"IF(W9>=1.5%,1,0)","v":1},{"$f":"PRODUCCION!AA11","v":1.3456810358957547E-2},{"$f":"IF(Y9>=1.5%,1,0)","v":0}]
["SGC","ESTADO DE ACCIONES CORRECTIVAS",{"$f":"'GESTION DE CALIDAD'!E7","v":0},{"$f":"IF(C10>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!G7","v":0},{"$f":"IF(E10>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!I7","v":0},{"$f":"IF(G10>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!K7","v":0},{"$f":"IF(I10>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!M7","v":0},{"$f":"IF(K10>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!O7","v":0},{"$f":"IF(M10>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!Q7","v":0},{"$f":"IF(O10>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!S7","v":0},{"$f":"IF(Q10>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!U7","v":0},{"$f":"IF(S10>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!W7","v":0},{"$f":"IF(U10>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!Y7","v":0},{"$f":"IF(W10>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!AA7","v":0.45833333333333331},{"$f":"IF(Y10>=70%,1,0)","v":0}]
[null,"AUDITORIA INTERNA",{"$f":"'GESTION DE CALIDAD'!E9","v":0},{"$f":"IF(C11>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!G9","v":"%"},{"$f":"IF(E11>=70%,1,0)","v":1},{"$f":"'GESTION DE CALIDAD'!I9","v":0},{"$f":"IF(G11>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!K9","v":0},{"$f":"IF(I11>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!M9","v":0},{"$f":"IF(K11>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!O9","v":0},{"$f":"IF(M11>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!Q9","v":0.30769230769230771},{"$f":"IF(O11>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!S9","v":0.15384615384615385},{"$f":"IF(Q11>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!U9","v":0.09},{"$f":"IF(S11>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!W9","v":0.23076923076923078},{"$f":"IF(U11>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!Y9","v":0.23076923076923078},{"$f":"IF(W11>=70%,1,0)","v":0},{"$f":"'GESTION DE CALIDAD'!AA9","v":0},{"$f":"IF(Y11>=70%,1,0)","v":0},null,{"$f":"SUM(C11,E11,G11,I11,K11,M11,O11,Q11,S11,U11,W11,Y11)","v":1.0130769230769232},{"$f":"IF(AB11>=70%,1,0)","v":1}]
["MANTENIMIENTO","% DISPONIBILIDAD",{"$f":"MANTENIMIENTO!E7","v":0.91566265060240959},{"$f":"IF(C12<70%,\"malo\",IF(C12<79%,\"regular\",IF(C12<89%,\"bueno\",IF(C12<95%,\"optimo\",IF(C12>=95%,\"fuera de rango\",\" \")))))","v":"optimo"},{"$f":"MANTENIMIENTO!G7","v":0.86770428015564205},{"$f":"IF(E12<70%,\"malo\",IF(E12<79%,\"regular\",IF(E12<89%,\"bueno\",IF(E12<95%,\"optimo\",IF(E12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!I7","v":0.88713036234902121},{"$f":"IF(G12<70%,\"malo\",IF(G12<79%,\"regular\",IF(G12<89%,\"bueno\",IF(G12<95%,\"optimo\",IF(G12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!K7","v":0.8303713690403236},{"$f":"IF(I12<70%,\"malo\",IF(I12<79%,\"regular\",IF(I12<89%,\"bueno\",IF(I12<95%,\"optimo\",IF(I12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!M7","v":0.89621318373071523},{"$f":"IF(K12<70%,\"malo\",IF(K12<79%,\"regular\",IF(K12<89%,\"bueno\",IF(K12<95%,\"optimo\",IF(K12>=95%,\"fuera de rango\",\" \")))))","v":"optimo"},{"$f":"MANTENIMIENTO!O7","v":0.83929636255217654},{"$f":"IF(M12<70%,\"malo\",IF(M12<79%,\"regular\",IF(M12<89%,\"bueno\",IF(M12<95%,\"optimo\",IF(M12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!Q7","v":0.83372277782970372},{"$f":"IF(O12<70%,\"malo\",IF(O12<79%,\"regular\",IF(O12<89%,\"bueno\",IF(O12<95%,\"optimo\",IF(O12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!S7","v":0.80469176213857063},{"$f":"IF(Q12<70%,\"malo\",IF(Q12<79%,\"regular\",IF(Q12<89%,\"bueno\",IF(Q12<95%,\"optimo\",IF(Q12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!U7","v":0.87144814176499186},{"$f":"IF(S12<70%,\"malo\",IF(S12<79%,\"regular\",IF(S12<89%,\"bueno\",IF(S12<95%,\"optimo\",IF(S12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!W7","v":0.79156023839931888},{"$f":"IF(U12<70%,\"malo\",IF(U12<79%,\"regular\",IF(U12<89%,\"bueno\",IF(U12<95%,\"optimo\",IF(U12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!Y7","v":0.82252233092301152},{"$f":"IF(W12<70%,\"malo\",IF(W12<79%,\"regular\",IF(W12<89%,\"bueno\",IF(W12<95%,\"optimo\",IF(W12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!AA7","v":0.9031941031941032},{"$f":"IF(Y12<70%,\"malo\",IF(Y12<79%,\"regular\",IF(Y12<89%,\"bueno\",IF(Y12<95%,\"optimo\",IF(Y12>=95%,\"fuera de rango\",\" \")))))","v":"optimo"}]
["CONTROL INTERNO","AUDITORIA INTERNA ",{"$f":"'CONTROL INTERNO'!E7","v":0},{"$f":"IF(C13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!G7","v":0},{"$f":"IF(E13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!I7","v":0},{"$f":"IF(G13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!K7","v":0},{"$f":"IF(I13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!M7","v":0},{"$f":"IF(K13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!O7","v":0},{"$f":"IF(M13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!Q7","v":0.30769230769230771},{"$f":"IF(O13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!S7","v":0.15384615384615385},{"$f":"IF(Q13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!U7","v":7.6923076923076927E-2},{"$f":"IF(S13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!W7","v":0.23076923076923078},{"$f":"IF(U13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!Y7","v":0.23076923076923078},{"$f":"IF(W13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!AA7","v":1},{"$f":"IF(Y13>=80%,1,0)","v":1}]
["ADMINISTRATIVA","ALMACENAMIENTO DE CLIENTES ",{"$f":"ADMINISTRATIVA!E7","v":0.17335222222222221},{"$f":"IF(C14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!G7","v":0.10806},{"$f":"IF(E14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!I7","v":7.8166666666666662E-2},{"$f":"IF(G14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!K7","v":5.6706666666666669E-2},{"$f":"IF(I14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!M7","v":5.5440000000000003E-2},{"$f":"IF(K14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!O7","v":4.1280000000000004E-2},{"$f":"IF(M14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!Q7","v":2.606E-2},{"$f":"IF(O14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!S7","v":1.0580000000000001E-2},{"$f":"IF(Q14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!U7","v":2.4946666666666669E-2},{"$f":"IF(S14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!W7","v":6.3333333333333332E-3},{"$f":"IF(U14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!Y7","v":1.2893333333333333E-2},{"$f":"IF(W14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!AA7","v":2.0660000000000001E-2},{"$f":"IF(Y14<=33%,1,0)","v":1}]
[null,"SGSST",{"$f":"ADMINISTRATIVA!E9","v":1},{"$f":"IF(C15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!G9","v":1},{"$f":"IF(E15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!I9","v":1},{"$f":"IF(G15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!K9","v":1},{"$f":"IF(I15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!M9","v":1},{"$f":"IF(K15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!O9","v":1},{"$f":"IF(M15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!Q9","v":1},{"$f":"IF(O15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!S9","v":1},{"$f":"IF(Q15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!U9","v":0.9},{"$f":"IF(S15=100%,1,0)","v":0},{"$f":"ADMINISTRATIVA!W9","v":0.9},{"$f":"IF(U15=100%,1,0)","v":0},{"$f":"ADMINISTRATIVA!Y9","v":1},{"$f":"IF(W15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!AA9","v":0.875},{"$f":"IF(Y15=100%,1,0)","v":0}]
["TECNOLOGIA DE LA INFORMACION\nY LA COMUNICACIÓN","SOPORTE",{"$f":"'GESTIÓN TECNOLOGICA'!E7","v":1},{"$f":"IF(C16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!G7","v":1},{"$f":"IF(E16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!I7","v":1},{"$f":"IF(G16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!K7","v":1},{"$f":"IF(I16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!M7","v":1},{"$f":"IF(K16<=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!O7","v":1},{"$f":"IF(M16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!Q7","v":1},{"$f":"IF(O16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!S7","v":1},{"$f":"IF(Q16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!U7","v":1},{"$f":"IF(S16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!W7","v":1},{"$f":"IF(U16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!Y7","v":1},{"$f":"IF(W16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!AA7","v":1},{"$f":"IF(Y16>=100%,1,0)","v":1}]
["COMERCIALIZACION","VENTAS",{"$f":"COMERCIALIZACIÓN!E7","v":0},{"$f":"IF(C17>=40%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!G7","v":1.6133055555555557E-2},{"$f":"IF(E17>=40%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!I7","v":5.0203888888888888E-2},{"$f":"IF(G17>=40%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!K7","v":7.2274722222222226E-2},{"$f":"IF(I17>=40%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!M7","v":4.7089166666666668E-2},{"$f":"IF(K17>=40%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!O7","v":0.11682111111111111},{"$f":"IF(M17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!Q7","v":6.6954166666666662E-2},{"$f":"IF(O17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!S7","v":0.10792388888888889},{"$f":"IF(Q17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!U7","v":9.374615384615384E-2},{"$f":"IF(S17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!W7","v":9.2656923076923081E-2},{"$f":"IF(U17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!Y7","v":9.2853846153846148E-2},{"$f":"IF(W17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!AA7","v":0.14000974358974358},{"$f":"IF(Y17>=100%,1,0)","v":0},null,{"$f":"COMERCIALIZACIÓN!AB7","v":0.85994358974358975},{"$f":"IF(AB17>=100%,1,0)","v":0}]
["JURIDICA","CONTRATOS OPORTUNOS",{"$f":"JURIDICA!E7","v":1},{"$f":"IF(C18>=100%,1,0)","v":1},{"$f":"JURIDICA!G7","v":1},{"$f":"IF(E18>=100%,1,0)","v":1},{"$f":"JURIDICA!I7","v":1},{"$f":"IF(G18>=100%,1,0)","v":1},{"$f":"JURIDICA!K7","v":1},{"$f":"IF(I18>=100%,1,0)","v":1},{"$f":"JURIDICA!M7","v":1},{"$f":"IF(K18>=100%,1,0)","v":1},{"$f":"JURIDICA!O7","v":1},{"$f":"IF(M18>=100%,1,0)","v":1},{"$f":"JURIDICA!Q7","v":1},{"$f":"IF(O18>=100%,1,0)","v":1},{"$f":"JURIDICA!S7","v":1},{"$f":"IF(Q18>=100%,1,0)","v":1},{"$f":"JURIDICA!U7","v":1},{"$f":"IF(S18>=100%,1,0)","v":1},{"$f":"JURIDICA!W7","v":1},{"$f":"IF(U18>=100%,1,0)","v":1},{"$f":"JURIDICA!Y7","v":1},{"$f":"IF(W18>=100%,1,0)","v":1},{"$f":"JURIDICA!AA7","v":1},{"$f":"IF(Y18>=100%,1,0)","v":1}]
["FINANCIERA","MARGEN OPERACIONAL",{"$f":"FINANCIERA!E7","v":-54.001859866663708},{"$f":"IF(C19>=17%,1,0)","v":0},{"$f":"FINANCIERA!G7","v":-2.3811300088182881},{"$f":"IF(E19>=17%,1,0)","v":0},{"$f":"FINANCIERA!I7","v":-0.35748883626014838},{"$f":"IF(G19>=17%,1,0)","v":0},{"$f":"FINANCIERA!K7","v":1.5662754510756504E-2},{"$f":"IF(I19>=17%,1,0)","v":0},{"$f":"FINANCIERA!M7","v":4.6345444498942297E-2},{"$f":"IF(K19>=17%,1,0)","v":0},{"$f":"FINANCIERA!O7","v":0.16359871931676054},{"$f":"IF(M19>=17%,1,0)","v":0},{"$f":"FINANCIERA!Q7","v":0.19466207402212959},{"$f":"IF(O19>=17%,1,0)","v":1},{"$f":"FINANCIERA!S7","v":0.24535500225989804},{"$f":"IF(Q19>=17%,1,0)","v":1},{"$f":"FINANCIERA!U7","v":0.30399356705877589},{"$f":"IF(S19>=17%,1,0)","v":1},{"$f":"FINANCIERA!W7","v":0.24978051533219744},{"$f":"IF(U19>=17%,1,0)","v":1},{"$f":"FINANCIERA!Y7","v":0.29732437215720209},{"$f":"IF(W19>=17%,1,0)","v":1},{"$f":"FINANCIERA!AA7","v":0.32269276168183259},{"$f":"IF(Y19>=17%,1,0)","v":1}]
["CONTROL DE CALIDAD","RECLAMOS ATENDIDOS",{"$f":"'CONTROL DE CALIDAD'!E7","v":1},{"$f":"IF(C20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!G7","v":1},{"$f":"IF(E20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!I7","v":1},{"$f":"IF(G20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!K7","v":1},{"$f":"IF(I20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!M7","v":0},{"$f":"IF(K20=100%,1,0)","v":0},{"$f":"'CONTROL DE CALIDAD'!O7","v":1},{"$f":"IF(M20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!Q7","v":1},{"$f":"IF(O20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!S7","v":1},{"$f":"IF(Q20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!U7","v":1},{"$f":"IF(S20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!W7","v":0},{"$f":"IF(U20=100%,1,0)","v":0},{"$f":"'CONTROL DE CALIDAD'!Y7","v":0},{"$f":"IF(W20=100%,1,0)","v":0},{"$f":"'CONTROL DE CALIDAD'!AA7","v":0},{"$f":"IF(Y20=100%,1,0)","v":0}]
[null,"PRODUCTOS NO CONFORMES",{"$f":"'CONTROL DE CALIDAD'!E10","v":2.3947951273532667E-2},{"$f":"IF(C21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!G10","v":1.0319393693327919E-3},{"$f":"IF(E21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!I10","v":3.558901093273933E-3},{"$f":"IF(G21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!K10","v":2.5045470903484967E-3},{"$f":"IF(I21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!M10","v":2.2073722206567099E-3},{"$f":"IF(K21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!O10","v":3.5756207098930821E-3},{"$f":"IF(M21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!Q10","v":3.3439260436227071E-3},{"$f":"IF(O21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!S10","v":6.6130178234223552E-3},{"$f":"IF(Q21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!U10","v":1.510047281323877E-2},{"$f":"IF(S21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!W10","v":0},{"$f":"IF(U21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!Y10","v":0},{"$f":"IF(W21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!AA10","v":0},{"$f":"IF(Y21<=3%,1,0)","v":1}]
[]
["BIMESTRAL"]
["PROCESOS","INDICADOR","1 BIMESTRE","META","2 BIMESTRE","META","3 BIMESTRE","META","4 BIMESTRE","META","5 BIMESTRE","META","6 BIMESTRE","META"]
["CONTROL INTERNO","ENTES EXTERNOS",{"$f":"'CONTROL INTERNO'!E11","v":1},{"$f":"IF(C25=100%,1,0)","v":1},{"$f":"'CONTROL INTERNO'!G11","v":1},{"$f":"IF(E25=100%,1,0)","v":1},{"$f":"'CONTROL INTERNO'!I11","v":1},{"$f":"IF(G25=100%,1,0)","v":1},{"$f":"'CONTROL INTERNO'!K11","v":1},{"$f":"IF(I25=100%,1,0)","v":1},{"$f":"'CONTROL INTERNO'!M15","v":1},{"$f":"IF(K25=100%,1,0)","v":1},{"$f":"'CONTROL INTERNO'!O15","v":1},{"$f":"IF(M25=100%,1,0)","v":1}]
[null,"ENTES EXTERNOS",{"$f":"'CONTROL INTERNO'!E12","v":0},{"$f":"IF(C26=100%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!G12","v":0},{"$f":"IF(E26=100%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!I12","v":0},{"$f":"IF(G26=100%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!K12","v":0},{"$f":"IF(I26=100%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!M16","v":0},{"$f":"IF(K26=100%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!O16","v":0},{"$f":"IF(M26=100%,1,0)","v":0}]
[null,"SIA",{"$f":"'CONTROL INTERNO'!E15","v":1},1,{"$f":"'CONTROL INTERNO'!G15","v":1},1,{"$f":"'CONTROL INTERNO'!I15","v":1},1,{"$f":"'CONTROL INTERNO'!K15","v":1},1,{"$f":"'CONTROL INTERNO'!M15","v":1},1,{"$f":"'CONTROL INTERNO'!O15","v":1},1]
[]
["SEMESTRAL",null,null,null,null,null,"ANUAL"]
["PROCESOS","INDICADOR","1 \nSEMESTRE","META","2 \nSEMESTRE","META","AÑO","META"]
["ADMINISTRATIVA","CAPACITACION",{"$f":"ADMINISTRATIVA!N11","v":0.16666666666666666},{"$f":"IF(C31>=50%,1,0)","v":0},{"$f":"ADMINISTRATIVA!Z11","v":0},{"$f":"IF(E31>=50%,1,0)","v":0},{"$f":"IF(SUM(C31,E31)>=100%,100%,SUM(C31,E31))","v":0.16666666666666666},{"$f":"IF(G31=100%,1,0)","v":0}]
["PLANEACIÓN","PROYECTOS",{"$f":"PLANEACION!E7","v":1},{"$f":"IF(C32>=90%,1,0)","v":1},{"$f":"PLANEACION!G7","v":1},{"$f":"IF(E32>=90%,1,0)","v":1},{"$f":"AVERAGE(C32,E32)","v":1},{"$f":"IF(G32>=90%,1,0)","v":1}]
[null,"FORMULACION PLAN ESTRATEGICO 2019-2022",{"$f":"PLANEACION!E9","v":1},{"$f":"IF(C33>=50%,1,0)","v":1},{"$f":"PLANEACION!G9","v":1},{"$f":"IF(E33>=50%,1,0)","v":1},{"$f":"IF(SUM(C33,E33)>=100%,100%,SUM(C33,E33))","v":1},{"$f":"IF(G33=100%,1,0)","v":1}]